Indus software technology 


Interview questions:


1st round:


1.roles nd responsibilities

2. Create a table
 
3.how to add column

4. Modify the column name

5.write a program using cursor

6. Refcursor

7. Diff b/w procedure nd function

8. Forall syntax

9. Using collection fetch 3 rows

10. Exceptions

11. Substr('Test', 1,3)
Output?

12.instr('Test', 1)
Output?

13. Pragma autonomous transaction

14. Write a prgm fr procedure

15. Program fr function

16.use of analytical function

17.diff b/w analytical nd group functions

2nd round:


1. Roles and responsibilities

2. Wat s pragma autonomous transaction nd where u have used n ur project

3. Exception nd types

4. Why we r using  "when others" exception?

5. Write a query to display sysdate as 13/07/2016 

6. Write a query to display time as 04.30 pm

7. Team size

8. Cursor

9. Gtt nd whr u have used n ur project

10. Y u want job Change?